Can I concatenate multiple MySQL rows into one field?

Question

Aryan Kumar · Answer

Yes, you can concatenate multiple MySQL rows into one field using the GROUP_CONCAT() function. The syntax is as follows:
SQL
SELECT GROUP_CONCAT(column_name, SEPARATOR) AS column_name
FROM table_name
GROUP BY column_name;
For example, if you have a table called products with the columns
name and price, you could use the following query to concatenate all product names into a single field:
SQL
SELECT GROUP_CONCAT(name, ',') AS names
FROM products
GROUP BY name;
This would return a single field with a comma-separated list of all product names.
Here is an example of how to use the GROUP_CONCAT() function in MySQL:
SQL
CREATE TABLE products (
  id INT NOT NULL AUTO_INCREMENT,
  name VARCHAR(255) NOT NULL,
  price INT NOT NULL,
  PRIMARY KEY (id)
);
INSERT INTO products (name, price) VALUES
('Product 1', 100),
('Product 2', 200),
('Product 3', 300);
SELECT GROUP_CONCAT(name, ',') AS names
FROM products
GROUP BY name;
This will return the following result:
names
Product 1,Product 2,Product 3
As you can see, the GROUP_CONCAT() function has concatenated all product names into a single field, separated by commas.
Here are some additional things to keep in mind when using the GROUP_CONCAT() function:
The GROUP_CONCAT() function only works with string columns.You can use the SEPARATOR keyword to specify a different separator character than a comma.You can use the DISTINCT keyword to remove duplicate values from the results.

forum

Can I concatenate multiple MySQL rows into one field?

Revati S Misra

Can you answer this question?

1 Answers

Liked By